# -*- coding: utf-8 -*-
import psycopg2
conn_params = {
    "dbname": "skqs",
    "user": "skqsdb",
    "password": "skqs!@#$",
    "port": "5432",
    "host": "hz.biot.shimge.com"
}
print(type(conn_params))
# 建立连接
conn = psycopg2.connect(**conn_params)

# 创建一个游标对象
cur = conn.cursor()

# 执行SQL查询
cur.execute("SELECT * FROM skqs_card  LIMIT 5;")

# 获取查询结果
rows = cur.fetchall()

# 打印结果
for row in rows:
    print(row)

# 关闭游标和连接
cur.close()
conn.close()